CREATE TABLE [dbo].[DuesCycles]
(
[CYCLE_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_CYCLE_NAME] DEFAULT (''),
[REPORT_FORM] [varchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_REPORT_FORM] DEFAULT (''),
[MEM_TYPES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_MEM_TYPES] DEFAULT (''),
[CATEGORIES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_CATEGORIES] DEFAULT (''),
[PRODUCT_CODES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INCLUDE_INACTIVE_MEMBERS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_INACTIVE_MEMBERS] DEFAULT ((0)),
[INCLUDE_SUSPENDED_MEMBERS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_SUSPENDED_MEMBERS] DEFAULT ((0)),
[INCLUDE_INACTIVE_SECTIONS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_INACTIVE_SECTIONS] DEFAULT ((0)),
[INCLUDE_ZERO_BALANCE] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_ZERO_BALANCE] DEFAULT ((0)),
[MAJOR_SORT] [tinyint] NOT NULL CONSTRAINT [DF_DuesCycles_MAJOR_SORT] DEFAULT ((0)),
[MEMBER_SORT] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_MEMBER_SORT] DEFAULT ((0)),
[PRODUCT_SORT] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_PRODUCT_SORT] DEFAULT ((0)),
[INITIAL_BILL_TITLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_INITIAL_BILL_TITLE] DEFAULT (''),
[INITIAL_BILL_TEXT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INITIAL_BILL_ADDRESS] [int] NOT NULL CONSTRAINT [DF_DuesCycles_INITIAL_BILL_ADDRESS] DEFAULT ((0)),
[INITIAL_BILL_END] [int] NOT NULL CONSTRAINT [DF_DuesCycles_INITIAL_BILL_END] DEFAULT ((0)),
[FIRST_REMINDER_TITLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_FIRST_REMINDER_TITLE] DEFAULT (''),
[FIRST_REMINDER_TEXT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIRST_REMINDER_ADDRESS] [int] NOT NULL CONSTRAINT [DF_DuesCycles_FIRST_REMINDER_ADDRESS] DEFAULT ((0)),
[FIRST_REMINDER_START] [int] NOT NULL CONSTRAINT [DF_DuesCycles_FIRST_REMINDER_START] DEFAULT ((0)),
[FIRST_REMINDER_END] [int] NOT NULL CONSTRAINT [DF_DuesCycles_FIRST_REMINDER_END] DEFAULT ((0)),
[SECOND_REMINDER_TITLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_SECOND_REMINDER_TITLE] DEFAULT (''),
[SECOND_REMINDER_TEXT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SECOND_REMINDER_ADDRESS] [int] NOT NULL CONSTRAINT [DF_DuesCycles_SECOND_REMINDER_ADDRESS] DEFAULT ((0)),
[SECOND_REMINDER_START] [int] NOT NULL CONSTRAINT [DF_DuesCycles_SECOND_REMINDER_START] DEFAULT ((0)),
[SECOND_REMINDER_END] [int] NOT NULL CONSTRAINT [DF_DuesCycles_SECOND_REMINDER_END] DEFAULT ((0)),
[INITIAL_BILL_START] [int] NOT NULL CONSTRAINT [DF_DuesCycles_INITIAL_BILL_START] DEFAULT ((0)),
[FORCE_ADD_OTHER] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_FORCE_ADD_OTHER] DEFAULT ((0)),
[INCLUDE_ALL_SECTIONS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_ALL_SECTIONS] DEFAULT ((0)),
[INCLUDE_ALL_CHAPTERS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_ALL_CHAPTERS] DEFAULT ((0)),
[INCLUDE_ALL_MEM_ITEMS] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_INCLUDE_ALL_MEM_ITEMS] DEFAULT ((0)),
[BILL_CYCLE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_BILL_CYCLE] DEFAULT (''),
[ACCOUNTING_METHOD] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_ACCOUNTING_METHOD] DEFAULT (''),
[MASS_BILL_ACCT_METH] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DuesCycles_MASS_BILL_ACCT_METH] DEFAULT (''),
[UPDATE_COMP_AT_PAY] [bit] NOT NULL CONSTRAINT [DF_DuesCycles_UPDATE_COMP_AT_PAY] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[DuesCycles] ADD CONSTRAINT [PK_DuesCycles] PRIMARY KEY CLUSTERED ([CYCLE_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[DuesCycles] TO [IMIS]
GRANT SELECT ON  [dbo].[DuesCycles] TO [IMIS]
GRANT INSERT ON  [dbo].[DuesCycles] TO [IMIS]
GRANT DELETE ON  [dbo].[DuesCycles] TO [IMIS]
GRANT UPDATE ON  [dbo].[DuesCycles] TO [IMIS]
GO